Digital Redlining EDA - Consolidated

Map Debug Tools Force Map Refresh Check Map Containers Debug Map Update

Data Loading and Preparation

## 
## === DIAGNOSTIC: Building Details All Students Data ===

## Number of rows: 105

## Column names: Building IRN, Building Name, District_IRN, District Name, County, Region, Student Group, Enrollment, Enrollment Percent, Attendance Rate, Mobility Rate, Chronic Absenteeism Rate

## Sample Building IRNs: 000224, 000489, 000575, 000729, 000736

## === After renaming columns ===

## # A tibble: 3 × 6
##   SchoolIRN SchoolName          Enrollment_Percent Attendance_Rate Mobility_Rate
##   <chr>     <chr>               <chr>              <chr>           <chr>        
## 1 000224    Adlai Stevenson Sc… 100.0              87.6            20.0         
## 2 000489    Almira              100.0              86.1            8.5          
## 3 000575    Northwest School o… 100.0              84.2            27.5         
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <chr>

## 
## === After numeric conversion ===

## # A tibble: 3 × 6
##   SchoolIRN SchoolName          Enrollment_Percent Attendance_Rate Mobility_Rate
##   <chr>     <chr>                            <dbl>           <dbl>         <dbl>
## 1 000224    Adlai Stevenson Sc…                  1           0.876         0.2  
## 2 000489    Almira                               1           0.861         0.085
## 3 000575    Northwest School o…                  1           0.842         0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>

## Using geocoded school data

## 
## === DIAGNOSTIC: Cleveland Schools Data (before merge) ===

## Number of rows: 105

## Column names: SchoolIRN ..., SchoolName ..., DistrictIRN ..., DistrictName ..., Latitude ..., Longitude ..., SyntheticCoords ..., geo_lat ..., geo_lng ..., geo_address ..., Address ...

## Sample SchoolIRNs: 000224, 000489, 000575, 000729, 000736

## 
## === DIAGNOSTIC: SchoolIRN Comparison ===

## First 5 SchoolIRNs in Cleveland Schools Data:  000224, 000489, 000575, 000729, 000736

## First 5 SchoolIRNs in Building Details Data:  000224, 000489, 000575, 000729, 000736

## Number of matching SchoolIRNs:  105  out of  105  schools

## 
## === DIAGNOSTIC: Cleveland Schools Data (after merge) ===

## Number of rows: 105

## Sample of joined data:

## # A tibble: 3 × 6
##   SchoolName          SchoolIRN Enrollment_Percent Attendance_Rate Mobility_Rate
##   <chr>               <chr>                  <dbl>           <dbl>         <dbl>
## 1 Adlai Stevenson Sc… 000224                     1           0.876         0.2  
## 2 Almira              000489                     1           0.861         0.085
## 3 Northwest School o… 000575                     1           0.842         0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>

## 
## Cleveland Buildings 22-23: 973 rows

## Cleveland Buildings 23-24: 936 rows

## Cleveland Buildings 23-24 (All Students): 105 rows

## Cleveland Student Opportunity 22-23: 1090 rows

## Cleveland Student Opportunity 23-24: 1050 rows

## Cleveland Schools Data: 105 rows

## Schools with values for Attendance Rate: 105

## Schools with values for Chronic Absenteeism Rate: 105

## Schools with values for Mobility Rate: 105

## Schools with values for Enrollment Percent: 105

1. Redlining Map (HOLC Grades + Schools)

## [1] "Schools data summary:"
## [1] "Number of schools: 105"
## [1] "School columns: SchoolIRN, SchoolName, DistrictIRN, DistrictName, Latitude, Longitude, SyntheticCoords, geo_lat, geo_lng, geo_address"
## [1] "Sample coordinates: -81.5509837, -81.7518031, -81.7671731 41.4548682, 41.4616156, 41.482455"

## Map dimensions:    x

2. Building Details Report - 2023-2024

The map below allows you to select different performance indicators to visualize across schools in Cleveland. Each indicator is color-coded to show variation in performance, with HOLC redlining districts displayed as background polygons.

Select Performance Indicator: Attendance Rate Mobility Rate Chronic Absenteeism Rate

## [1] "Available columns in cleveland_schools_data:"

##  [1] "SchoolIRN"                "SchoolName"              
##  [3] "DistrictIRN"              "DistrictName"            
##  [5] "Latitude"                 "Longitude"               
##  [7] "SyntheticCoords"          "geo_lat"                 
##  [9] "geo_lng"                  "geo_address"             
## [11] "Address"                  "Enrollment_Percent"      
## [13] "Attendance_Rate"          "Mobility_Rate"           
## [15] "Chronic_Absenteeism_Rate"

About the Enhanced Performance Map: This interactive map now uses real performance data from the Building Details Report 23-24 for the “All Students” subgroup. The map displays Cleveland schools colored by their performance on three key indicators:

• Attendance Rate: Percentage of students with regular attendance (higher is better)
• Mobility Rate: Percentage of students who moved during the year (lower is better)
• Chronic Absenteeism Rate: Percentage of students missing 10% or more school days (lower is better)

Schools are displayed on top of the historical redlining districts from the 1930s HOLC. The system automatically handles “NC” (not counted) values by treating them as missing data. Use the dropdown above the map to switch between indicators - the school dots will change colors accordingly, and a dynamic legend shows the color scale for each indicator.

3. Building Student Opportunity Report - 2023-2024

The maps below visualize data from the Building Student Opportunity Report for Cleveland schools. Each indicator shows opportunities and resources available to students, with HOLC redlining districts displayed as background polygons.

Select Student Opportunity Indicator: All-Day Kindergarten Enrollment Physical Education/Wellness Course Enrollment World Language Course Enrollment Career Technical Education Enrollment (Grades 7-12) Cocurricular Activities Participation Advanced Courses Participation (AP, IB, Honors, CCP) Gifted Services Enrichment/Support Programs Outside School Day School Breakfast Program Participation School Bus Transportation Portable Technology Devices Ratio

## Loaded Student Opportunity data for 105 schools

## Available indicators:

##  - All-Day Kindergarten Enrollment : 105 schools with data
##  - Physical Education/Wellness Course Enrollment : 105 schools with data
##  - World Language Course Enrollment : 105 schools with data
##  - Career Technical Education Enrollment (Grades 7-12) : 105 schools with data
##  - Cocurricular Activities Participation : 105 schools with data
##  - Advanced Courses Participation (AP, IB, Honors, CCP) : 105 schools with data
##  - Gifted Services : 105 schools with data
##  - Enrichment/Support Programs Outside School Day : 105 schools with data
##  - School Breakfast Program Participation : 105 schools with data
##  - Students Transported by School Bus : 105 schools with data
##  - Portable Technology Devices Ratio : 105 schools with data